﻿CREATE TABLE [dbo].[TicketClass] (
    [Id]                            INT           IDENTITY (1, 1) NOT NULL,
    [Name]                          NVARCHAR (50) NULL,
    [SeatClassId]                   INT           NULL,
    [Price]                         FLOAT (53)    NULL,
    [IsCancel]                      BIT           NULL,
    [IsUpgradeClass]                BIT           NULL,
    [IsChangeTrip]                  BIT           NULL,
    [CancelBeforeDepartureCost]     FLOAT (53)    NULL,
    [CancelAfterDepartureCost]      FLOAT (53)    NULL,
    [UpgradeClassBeforeDeparture]   FLOAT (53)    NULL,
    [ChangeTripBeforeDepartureCost] FLOAT (53)    NULL,
    [ChangeTripAfterDepartureCost]  FLOAT (53)    NULL,
    [CoefficientBonusMiles]         FLOAT (53)    NULL,
    [ExpiredMonthAmount]            INT           NULL,
    [Currency]                      VARCHAR (10)  NULL,
    CONSTRAINT [PK_Loai_ve] PRIMARY KEY CLUSTERED ([Id] ASC)
);

